
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>
	<head>
		<title>Hibernate Mappings - Table Info</title>
		<link rel="stylesheet" type="text/css" href="../../assets/doc-style.css" title="Style"/>
	</head>
	<body>

	<div id="header">

		<div id="logo">
			<a href="http://www.hibernate.org/" target="_blank">
				<img src="../../assets/hibernate_logo.gif" alt="Hibernate"/>
			</a>
		</div>

		<ul><li><a href="../index.html" target="_top">Tables</a></li><li><a href="../../entities/index.html" target="_top">Entities</a></li></ul>

		<hr/>

	</div>

		<h4>Schema magento.default</h4>
		<h2>Table catalog_product_index_price</h2>

			<p></p>

		<table id="column_summary">
			<thead>
				<tr>
					<th class="MainTableHeading" colspan="7">
						Column Summary
					</th>
				</tr>
				<tr>
					<th style="width: 14%">
						Name
					</th>
					<th style="width: 14%">
						SqlType
					</th>
					<th style="width: 14%">
						Length
					</th>
					<th style="width: 14%">
						Precision
					</th>
					<th style="width: 14%">
						Scale
					</th>
					<th style="width: 14%">
						Nullable
					</th>
					<th style="width: 14%">
						Unique
					</th>
				</tr>
			</thead>
			<tbody>
					<tr>
						<td>
							<a href="#column_detail_entity_id">
								entity_id
							</a>
						</td>
						<td>
							N/D
						</td>
						<td>
							255
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							false
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_customer_group_id">
								customer_group_id
							</a>
						</td>
						<td>
							smallint
						</td>
						<td>
							255
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							false
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_website_id">
								website_id
							</a>
						</td>
						<td>
							smallint
						</td>
						<td>
							255
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							false
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_tax_class_id">
								tax_class_id
							</a>
						</td>
						<td>
							smallint
						</td>
						<td>
							255
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							true
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_price">
								price
							</a>
						</td>
						<td>
							decimal(12,4)
						</td>
						<td>
							255
						</td>
						<td>
							12
						</td>
						<td>
							4
						</td>
						<td>
							true
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_final_price">
								final_price
							</a>
						</td>
						<td>
							decimal(12,4)
						</td>
						<td>
							255
						</td>
						<td>
							12
						</td>
						<td>
							4
						</td>
						<td>
							true
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_min_price">
								min_price
							</a>
						</td>
						<td>
							decimal(12,4)
						</td>
						<td>
							255
						</td>
						<td>
							12
						</td>
						<td>
							4
						</td>
						<td>
							true
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_max_price">
								max_price
							</a>
						</td>
						<td>
							decimal(12,4)
						</td>
						<td>
							255
						</td>
						<td>
							12
						</td>
						<td>
							4
						</td>
						<td>
							true
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_tier_price">
								tier_price
							</a>
						</td>
						<td>
							decimal(12,4)
						</td>
						<td>
							255
						</td>
						<td>
							12
						</td>
						<td>
							4
						</td>
						<td>
							true
						</td>
						<td>
							false
						</td>
					</tr>
			</tbody>
		</table>

		<table id="primary_key">
			<thead>
				<tr>
					<th class="MainTableHeading" colspan="2">
						Primary Key
					</th>
				</tr>
				<tr>
					<th style="width: 50%">
						Name
					</th>
					<th style="width: 50%">
						Columns
					</th>
				</tr>
			</thead>
			<tbody>
					<tr>
						<td>
								PRIMARY
						</td>
						<td>
								<a href="#column_detail_entity_id">
									entity_id
								</a>
								<a href="#column_detail_customer_group_id">
									customer_group_id
								</a>
								<a href="#column_detail_website_id">
									website_id
								</a>
						</td>
					</tr>
			</tbody>
		</table>

			<table id="foreign_keys">
				<thead>
					<tr>
						<th class="MainTableHeading" colspan="3">
							Foreign Keys
						</th>
					</tr>
					<tr>
						<th style="width: 33%">
							Name
						</th>
						<th style="width: 33%">
							Referenced Table
						</th>
						<th style="width: 33%">
							Columns
						</th>
					</tr>
				</thead>
				<tbody>
						<tr>
							<td>
								FK_CAT_PRD_IDX_PRICE_WS_ID_CORE_WS_WS_ID
							</td>
							<td>
								<a href="core_website.html" target="generalFrame">
									core_website
								</a>
							</td>
							<td>
									<a href="#column_detail_website_id">
										website_id
									</a>
							</td>
						</tr>
						<tr>
							<td>
								FK_CAT_PRD_IDX_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID
							</td>
							<td>
								<a href="catalog_product_entity.html" target="generalFrame">
									catalog_product_entity
								</a>
							</td>
							<td>
									<a href="#column_detail_entity_id">
										entity_id
									</a>
							</td>
						</tr>
						<tr>
							<td>
								FK3E7EFB2658BE8130
							</td>
							<td>
								<a href="catalog_product_entity.html" target="generalFrame">
									catalog_product_entity
								</a>
							</td>
							<td>
									<a href="#column_detail_entity_id">
										entity_id
									</a>
							</td>
						</tr>
						<tr>
							<td>
								FK3E7EFB269E8133D
							</td>
							<td>
								<a href="customer_group.html" target="generalFrame">
									customer_group
								</a>
							</td>
							<td>
									<a href="#column_detail_customer_group_id">
										customer_group_id
									</a>
							</td>
						</tr>
						<tr>
							<td>
								FK3E7EFB26E0B7771B
							</td>
							<td>
								<a href="core_website.html" target="generalFrame">
									core_website
								</a>
							</td>
							<td>
									<a href="#column_detail_website_id">
										website_id
									</a>
							</td>
						</tr>
						<tr>
							<td>
								FK_CAT_PRD_IDX_PRICE_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID
							</td>
							<td>
								<a href="customer_group.html" target="generalFrame">
									customer_group
								</a>
							</td>
							<td>
									<a href="#column_detail_customer_group_id">
										customer_group_id
									</a>
							</td>
						</tr>
				</tbody>
			</table>
			
			<table id="unique_keys">
				<thead>
					<tr>
						<th class="MainTableHeading" colspan="2">
							Unique Keys
						</th>
					</tr>
					<tr>
						<th style="width: 50%">
							Name
						</th>
						<th style="width: 50%">
							Columns
						</th>
					</tr>
				</thead>
				<tbody>
						<tr>
							<td>
								PRIMARY
							</td>
							<td>
									<a href="#column_detail_entity_id">
										entity_id
									</a>
									<a href="#column_detail_customer_group_id">
										customer_group_id
									</a>
									<a href="#column_detail_website_id">
										website_id
									</a>
							</td>
						</tr>
				</tbody>
			</table>
		
			<table id="indexes">
				<thead>
					<tr>
						<th class="MainTableHeading" colspan="2">
							Indexes
						</th>
					</tr>
					<tr>
						<th style="width: 50%">
							Name
						</th>
						<th style="width: 50%">
							Columns
						</th>
					</tr>
				</thead>
				<tbody>
						<tr>
							<td>
								IDX_CATALOG_PRODUCT_INDEX_PRICE_CUSTOMER_GROUP_ID
							</td>
							<td>
									<a href="#column_detail_customer_group_id">
										customer_group_id
									</a>
							</td>
						</tr>
						<tr>
							<td>
								IDX_CATALOG_PRODUCT_INDEX_PRICE_MIN_PRICE
							</td>
							<td>
									<a href="#column_detail_min_price">
										min_price
									</a>
							</td>
						</tr>
						<tr>
							<td>
								IDX_CATALOG_PRODUCT_INDEX_PRICE_WEBSITE_ID
							</td>
							<td>
									<a href="#column_detail_website_id">
										website_id
									</a>
							</td>
						</tr>
				</tbody>
			</table>
		
			<p id="column_detail" class="MainTableHeading">
				Column Detail
			</p>
				
				<h3 id="column_detail_entity_id">entity_id</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> N/D
					</li>
					<li>
						<strong>Length:</strong> 255
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> false
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Entity ID
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_customer_group_id">customer_group_id</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> smallint
					</li>
					<li>
						<strong>Length:</strong> 255
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> false
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Customer Group ID
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_website_id">website_id</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> smallint
					</li>
					<li>
						<strong>Length:</strong> 255
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> false
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Website ID
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_tax_class_id">tax_class_id</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> smallint
					</li>
					<li>
						<strong>Length:</strong> 255
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> true
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Tax Class ID
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_price">price</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> decimal(12,4)
					</li>
					<li>
						<strong>Length:</strong> 255
					</li>
					<li>
						<strong>Precision:</strong> 12
					</li>
					<li>
						<strong>Scale:</strong> 4
					</li>
					<li>
						<strong>Nullable:</strong> true
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Price
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_final_price">final_price</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> decimal(12,4)
					</li>
					<li>
						<strong>Length:</strong> 255
					</li>
					<li>
						<strong>Precision:</strong> 12
					</li>
					<li>
						<strong>Scale:</strong> 4
					</li>
					<li>
						<strong>Nullable:</strong> true
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Final Price
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_min_price">min_price</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> decimal(12,4)
					</li>
					<li>
						<strong>Length:</strong> 255
					</li>
					<li>
						<strong>Precision:</strong> 12
					</li>
					<li>
						<strong>Scale:</strong> 4
					</li>
					<li>
						<strong>Nullable:</strong> true
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Min Price
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_max_price">max_price</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> decimal(12,4)
					</li>
					<li>
						<strong>Length:</strong> 255
					</li>
					<li>
						<strong>Precision:</strong> 12
					</li>
					<li>
						<strong>Scale:</strong> 4
					</li>
					<li>
						<strong>Nullable:</strong> true
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Max Price
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_tier_price">tier_price</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> decimal(12,4)
					</li>
					<li>
						<strong>Length:</strong> 255
					</li>
					<li>
						<strong>Precision:</strong> 12
					</li>
					<li>
						<strong>Scale:</strong> 4
					</li>
					<li>
						<strong>Nullable:</strong> true
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Tier Price
					</li>
				</ul>


				<hr/>
				

	</body>
</html>
